package com.yssoft.controller.supervise;

public class ProductionInfo {
	private Integer  batchId;
	private Integer  productId;
	private Integer  worksheetId;
	private String   worksheetPDate;
	private String  batchCode;
	private String  worksheetCode;
	private String  productName;
	private String  standardNum;
	private String  unit;
	private String  specifications;
	private String  workshopName;
	private String  productionLineName;
	private String  worksheetCreateTime;
	public Integer getBatchId() {
		return batchId;
	}
	public void setBatchId(Integer batchId) {
		this.batchId = batchId;
	}
	public Integer getProductId() {
		return productId;
	}
	public void setProductId(Integer productId) {
		this.productId = productId;
	}
	public Integer getWorksheetId() {
		return worksheetId;
	}
	public void setWorksheetId(Integer worksheetId) {
		this.worksheetId = worksheetId;
	}
	public String getBatchCode() {
		return batchCode;
	}
	public void setBatchCode(String batchCode) {
		this.batchCode = batchCode;
	}
	public String getWorksheetCode() {
		return worksheetCode;
	}
	public void setWorksheetCode(String worksheetCode) {
		this.worksheetCode = worksheetCode;
	}
	public String getProductName() {
		return productName;
	}
	public void setProductName(String productName) {
		this.productName = productName;
	}
	public String getStandardNum() {
		return standardNum;
	}
	public void setStandardNum(String standardNum) {
		this.standardNum = standardNum;
	}
	public String getUnit() {
		return unit;
	}
	public void setUnit(String unit) {
		this.unit = unit;
	}
	public String getSpecifications() {
		return specifications;
	}
	public void setSpecifications(String specifications) {
		this.specifications = specifications;
	}
	public String getWorkshopName() {
		return workshopName;
	}
	public void setWorkshopName(String workshopName) {
		this.workshopName = workshopName;
	}
	public String getProductionLineName() {
		return productionLineName;
	}
	public void setProductionLineName(String productionLineName) {
		this.productionLineName = productionLineName;
	}
	public String getWorksheetCreateTime() {
		return worksheetCreateTime;
	}
	public void setWorksheetCreateTime(String worksheetCreateTime) {
		this.worksheetCreateTime = worksheetCreateTime;
	}
	public String getWorksheetPDate() {
		return worksheetPDate;
	}
	public void setWorksheetPDate(String worksheetPDate) {
		this.worksheetPDate = worksheetPDate;
	}
	
}


/*select  b.id batchId,p.id productId, w.id  worksheetId,
b.code batchCode,w.code worksheetCode,
p.name productName,p.standard_num standardNum,p.unit unit,p.specifications  specifications,
ws.workshopName,pl.productionLineName,  DATE_FORMAT ( w.create_time,'%Y-%m-%d')  worksheetCreateTime
from t_worksheet  w 
left join   t_batch b on w.t_b_id=b.id
left join  t_products p on b.t_source_id=p.id

left join (
	select id workshopId,name workshopName  from t_dd_detail workshop where workshop.classify='workshop'

) ws  on ws.workshopId=w.workshop_id
left join (
	select id productionLineId ,name productionLineName  from t_dd_detail productionLine where productionLine.classify='productionLine'
) pl on pl.productionLineId=w.production_line_id*/